UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sh6D9rW42HlsuxNvL8nbOtBXeYFuznRH6PgtuH5XoEs='
WHERE
key_id = 'c569adad9c948a79f2b0b09f1095da6489cf0b778ad8011a4391c27c606518d9'
AND (
token = 'sh6D9rW42HlsuxNvL8nbOtBXeYFuznRH6PgtuH5XoEs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)