UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G+8XFOai8NZdJIj1Yq/EyFuTL6HkZUs7FxmR826G1NE='
WHERE
key_id = 'fca04ab7fbb28504baf08b3c645778bedb554ff85eaa3f7f1ee001b3b984eaac'
AND (
token = 'G+8XFOai8NZdJIj1Yq/EyFuTL6HkZUs7FxmR826G1NE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)