UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N4oTHr+X6A75ZA3kFn6lcdp8D8zumFnAbNH7FuyNk7U='
WHERE
key_id = '75707f46cf33bb6a220b18fdf11345e0adcbff447ad2144a7e38406f8f20c436'
AND (
token = 'N4oTHr+X6A75ZA3kFn6lcdp8D8zumFnAbNH7FuyNk7U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)