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