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