UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CZI9HQn4cqyGttaHEGJo6jZGbOupjQNNyCg+4pO1SVY='
WHERE
key_id = '6cc6b98d2b2f1e55f1fd27d5067d5eea220f8589e2d1a5c5928f916b0de4f900'
AND (
token = 'CZI9HQn4cqyGttaHEGJo6jZGbOupjQNNyCg+4pO1SVY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)