UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X9eYQ+ESAQXvbnMfgvK5FZXqikmnT0nmFci9TP1m/Ew='
WHERE
key_id = '3e974322f092e6c67ef00eefab00036343353f8ef293a6643cda518d0b58db9f'
AND (
token = 'X9eYQ+ESAQXvbnMfgvK5FZXqikmnT0nmFci9TP1m/Ew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)