UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sHciHMoup6dUdE+F03X2AM2DR4L+hzb6kcn5dp68LvY='
WHERE
key_id = 'b7ac3b7bf7ea47cdc21013eea8fde6d3e721043a226bbc944f087dc01511ec0a'
AND (
token = 'sHciHMoup6dUdE+F03X2AM2DR4L+hzb6kcn5dp68LvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)