UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NYH7PfmUSOEm+ipy+toybr6TPrK5n49e27IgvFlxRKg='
WHERE
key_id = 'a2b4f95cd8c1ec75695028b063fc62222a22f018aa9c9c87172196d3fbe306de'
AND (
token = 'NYH7PfmUSOEm+ipy+toybr6TPrK5n49e27IgvFlxRKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)