UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QxY5jFUNR3gc+SMdSngc+DuDL4BGk21fd4D7ppQEhoU='
WHERE
key_id = '31b0e9fa02499ac568a36461101b8d38f3855c1eeade2ab672366a4f89de83c2'
AND (
token = 'QxY5jFUNR3gc+SMdSngc+DuDL4BGk21fd4D7ppQEhoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)