UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CDsspzc6DRM06ByKu0yxQENuD3xF1EW0kFkM+2ZhsoY='
WHERE
key_id = 'fc5843bf4c9ca77a82d21974287bc8a375fd49cce54a8224c3b0a0374c59e31e'
AND (
token = 'CDsspzc6DRM06ByKu0yxQENuD3xF1EW0kFkM+2ZhsoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)