UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IWCx3COptmUzeBSoYRrMYWl7K8RwAjGAq27cTJLrLP4='
WHERE
key_id = '7eafb0e5d93110c589faedbe61b6a74663a31859377737974fb58793de9ff1a8'
AND (
token = 'IWCx3COptmUzeBSoYRrMYWl7K8RwAjGAq27cTJLrLP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)