UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0hpUG70D2MpgIRqayEOT5gqQv+CHPL3mX3R/YJknvKY='
WHERE
key_id = '3dd9de6f40284c1eac949c080691291857842ada1d026d985960e7a139b84f97'
AND (
token = '0hpUG70D2MpgIRqayEOT5gqQv+CHPL3mX3R/YJknvKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)