UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XJKsyhW8nSwDboRikAbRnDJthOvyoPbVYx7r/6b1RhI='
WHERE
key_id = 'dc4028f7a7948310274c932f8ae3c23e364c4eccdd57ef30b582ceb837fb0da3'
AND (
token = 'XJKsyhW8nSwDboRikAbRnDJthOvyoPbVYx7r/6b1RhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)