UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNjNHfMgj66Q1BSE0G6tKC5EcmhIZg//SngqwDil/iw='
WHERE
key_id = 'adde12c5f1b411a5f01eda44fd451c59e68153802295751a4cbb93e06dfbf08b'
AND (
token = 'zNjNHfMgj66Q1BSE0G6tKC5EcmhIZg//SngqwDil/iw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)