UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UwZ2yKpI6KA8d0uCX8HYLn7k9HlVCbsXw3jVIfC9dcE='
WHERE
key_id = '42e7cd4cdb97379838311799a66b813f83a7ac79e85adc19ed2dc723f2d7fe12'
AND (
token = 'UwZ2yKpI6KA8d0uCX8HYLn7k9HlVCbsXw3jVIfC9dcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)