UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm/JsLSjSdoPp7I6jzneDWzx8FBguQH8vVao/GUkT4I8='
WHERE
key_id = '47a46515f85985e981c96462052b71dab110be77b02d9bccb3191809cfb241bc'
AND (
token = 'm/JsLSjSdoPp7I6jzneDWzx8FBguQH8vVao/GUkT4I8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)