UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KOwK2ZiXiQXNu7RI6EWHoDhTHlcLJmPDnMYx4jJsEHA='
WHERE
key_id = '59a7c27b2a6b45c331f457d47b2a4e6b32388206dffae0b1bb86b30e427ee4cb'
AND (
token = 'KOwK2ZiXiQXNu7RI6EWHoDhTHlcLJmPDnMYx4jJsEHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)