UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L9L4/x9XwqNF0S/+453AbcVUd5IkBqEvM7cJ7pLKKsM='
WHERE
key_id = 'e080a0150597a08485206c8357ebd6a92879897755a5f4c887c3f7afc84346c2'
AND (
token = 'L9L4/x9XwqNF0S/+453AbcVUd5IkBqEvM7cJ7pLKKsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)