UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6y8p7BFByCY8vqQ4y/6L8vC8jfq/YM9Jwr7cc26OV6g='
WHERE
key_id = 'b4dc9189e4bcd056223766222c17b139fbd13a158c70e480be9cef5b1a86434a'
AND (
token = '6y8p7BFByCY8vqQ4y/6L8vC8jfq/YM9Jwr7cc26OV6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)