UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dQ/RhxMZ5mKqxcklZw+WtdAHkvKmAu6D5pAr8uc7qAo='
WHERE
key_id = '1c1e4e3cc7f392bd4d657bcb293d089f1f39579565208e84bf4d39743ada9bf7'
AND (
token = 'dQ/RhxMZ5mKqxcklZw+WtdAHkvKmAu6D5pAr8uc7qAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)