UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oGhi1XsLfF7v8whkv4mNT1wZ1kYypuWKrBX7jxKobSU='
WHERE
key_id = '049567debc94f4901aa8ae593b8e2c85a609c96965de02e7458b0a261ea58080'
AND (
token = 'oGhi1XsLfF7v8whkv4mNT1wZ1kYypuWKrBX7jxKobSU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)