UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LIHx6kKVb0afkmnmzEX+n5XqfgOEb2W/cgxiJ/kcsXw='
WHERE
key_id = 'e29a2ffb162601fd0b17fad3ce094464616bb12e014550e72436cc4e03937a64'
AND (
token = 'LIHx6kKVb0afkmnmzEX+n5XqfgOEb2W/cgxiJ/kcsXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)