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