UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q2HCNy293GLvgt3cFCeH8MmGLLu2Te2bR+M+adce0Yw='
WHERE
key_id = '6ce55b52500c609136e4089830aa33b60a5c9bf27ad404013936f6d3d0e60f75'
AND (
token = 'q2HCNy293GLvgt3cFCeH8MmGLLu2Te2bR+M+adce0Yw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)