UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cRi97iQFX8p65VzUdDswFKT5WXUpknVI7JVY47wTwbo='
WHERE
key_id = 'd03d905b8e3156788b6d2a62742f45847b5b9d730ff928b1796da4ad3e378732'
AND (
token = 'cRi97iQFX8p65VzUdDswFKT5WXUpknVI7JVY47wTwbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)