UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X7KzJqlZ5a87R+MvSY9ouC93gdQ0IBWjggaptQCxKIU='
WHERE
key_id = 'e3dc22b2ada14bdbd291f0e10b9d68799448aec6c9a3b9152b8df3d4abe0f107'
AND (
token = 'X7KzJqlZ5a87R+MvSY9ouC93gdQ0IBWjggaptQCxKIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)