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