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