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