UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2hiYDCRJUm3zFzrLOnWfwVvLYB+R91fUK4C1f9iFZ0w='
WHERE
key_id = '54e0345a244ef7454c41cfc3ff8b554631724f5c371aefff406af1744aedf88e'
AND (
token = '2hiYDCRJUm3zFzrLOnWfwVvLYB+R91fUK4C1f9iFZ0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)