UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wcS964d9VpZZ6HbeIubg4ftudQl336Q6VvZ/LLWCZQI='
WHERE
key_id = 'b09016deacd5ce090505f6cae30fd570a6de61241d9fa83c38f96f35b7f9bf4f'
AND (
token = 'wcS964d9VpZZ6HbeIubg4ftudQl336Q6VvZ/LLWCZQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)