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