UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8E96QlW36DNxmpJN1/tJ4IXNG1pfydoWaS9yul0yzMY='
WHERE
key_id = 'a114c4886bc215797399f529586b8c53411d7002e0c3e878f0582f02e1ef5a9e'
AND (
token = '8E96QlW36DNxmpJN1/tJ4IXNG1pfydoWaS9yul0yzMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)