UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hcYo4pTbMqUdVgCdoeK66i95HtOYFvIkLn+ErqoH6Nk='
WHERE
key_id = 'c2333c68f3ac94a61f26dbc85fcef245b9d1ed0590169e3ee80c681d3055ce70'
AND (
token = 'hcYo4pTbMqUdVgCdoeK66i95HtOYFvIkLn+ErqoH6Nk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)