UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fsgj6oYt/y4VT8pFkjTaFyr1W6qZTE0jp1Z10uXXAGE='
WHERE
key_id = '1ad90ea2def465e5c47a0ac0eb238b1a8066e27437aac74ffbdc067d69c51227'
AND (
token = 'fsgj6oYt/y4VT8pFkjTaFyr1W6qZTE0jp1Z10uXXAGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)