UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1MCKq0d09BEnad/vCidtqOtSRkdA2ptn1rAM2sWa2E='
WHERE
key_id = '727e47b12b4636c7725d534689a24dd596ce9d1c2367ca0b2665cff3229bb583'
AND (
token = 'z1MCKq0d09BEnad/vCidtqOtSRkdA2ptn1rAM2sWa2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)