UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yF1qA5LWeVxRqMyTuQxA1+GeoulXVFuVT/I9yWWfJO8='
WHERE
key_id = '8e41c8b6f55707fa99597b29917788408174fd3381d0a55db27485f93631e160'
AND (
token = 'yF1qA5LWeVxRqMyTuQxA1+GeoulXVFuVT/I9yWWfJO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)