UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X7juFuJLY8bzRDCxHwVsMAOULPeGn40x7N8agi4npMI='
WHERE
key_id = '3c027399446a6ea847afa8208557a4347139923c25bce1d5569fb1e567c0b4d2'
AND (
token = 'X7juFuJLY8bzRDCxHwVsMAOULPeGn40x7N8agi4npMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)