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